package models;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;


public class Categoria {


	  int id;
    String nome;
        
    public int getid() {
		return id;
	}
	public void setid(int id) {
		this.id = id;
	}
	
	public String getnome() {
		return nome;
	}
	public void setnome(String nome ) {
		this.nome = nome ;
	}
	

	private static Connection conexao;
	private static Statement comando;
	
	/***********************************************************************************/
	
	protected static void conectar() throws SQLException {  
		try {
			Class.forName("org.postgresql.Driver");
		} catch (ClassNotFoundException e) {
		}

			conexao = DriverManager.getConnection(  
			        "jdbc:postgresql://localhost:5432/SGRv2",  
			        "postgres",  
			        "senha");
		
			comando =  conexao.createStatement();
	}

	/*********************************************************************************/
	
	public static List<Categoria> Categorias (int categ) throws SQLException
	{
		conectar();
    	
    	ResultSet reader = comando.executeQuery("select * from categoria where idpai =" + categ);
    	  
    	
		List<Categoria> categs = new ArrayList<Categoria>();
		
		 while (reader.next())
	        {   			 
			 Categoria novo = new Categoria();
	            try
	            {
	                novo.setid(((int)reader.getInt("id") ));
	            }
	            catch (Exception e) {
				}
	            try
	            {
	                novo.setnome((String)reader.getString("nome"));
	            }
	            catch (Exception e) {
				}
	            
	            categs.add(novo);
	        }
		
		return categs;
	}

	/*********************************************************************************/
	
	
}
